03. Exercise: Pie Charts

Exercise: Pie Charts

In the following exercise, you'll open a spreadsheet of Financial information copied from Wikipedia containing information about the S&P 500 index companies, sp500_companies.xlsx. You'll use what you've learned about pivot tables and pie charts to answer questions about the data.

Task Description:

The following list has a series of steps for this exercise. As you complete each step, check it off the list. The quizzes in the task list can be found below.

Task List:

Task Feedback:

Congratulations!

Counts

QUESTION:

How many of the stocks are in the Energy sector?

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

Percentages

QUESTION:

What percentage of the S&P 500 stocks are in the Information Technology sector? (nearest whole percentage)

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

Next Concept